//
//  dataBaseHandle.h
//  HealthA段
//
//  Created by dllo on 15/6/10.
//  Copyright (c) 2015年 www.lanou3g.com 蓝鸥科技. All rights reserved.
//

#import <Foundation/Foundation.h>
#import <sqlite3.h>
#import "Base.h"
@interface dataBaseHandle : NSObject
{
    //定义一个成员变量,用来指向数据库
    sqlite3 *dbPoint;
}

//单例
+ (instancetype)shareDB;

//打开数据库
- (void)openDB;
//创建健康知识表
- (void)creatKnowTable;
//插入健康知识收藏
-(void)insertKnowthWithTitle:(NSString *)title imgUrl:(NSString *)imgUrl id:(NSInteger)id;
//查询
- (NSMutableArray *)selectKnowTable;
//删除内容
- (void)deleteKnowTableWithTitle:(NSString *)title;
//删除表
- (void)dropKnowTable;



//创建健康食谱表
-(void)creatFoudTable;
//插入健康食谱收藏
-(void)insertFoudthWithTitle:(NSString *)title imgUrl:(NSString *)imgUrl id:(NSInteger)id;
//查询
- (NSMutableArray *)selectFoudTable;
//删除内容
- (void)deleteFoudTableWithTitle:(NSString *)title;
//删除表
- (void)dropFoudTable;



//创建手术项目谱表
-(void)creatOperationTable;
//插入手术项目收藏
-(void)insertOperationthWithTitle:(NSString *)title imgUrl:(NSString *)imgUrl id:(NSInteger)id;
//查询
- (NSMutableArray *)selectOperationTable;
//删除内容
- (void)deleteOperationTableWithTitle:(NSString *)title;
//删除表
- (void)dropOperationTable;



//创建检查项目谱表
-(void)creatInspectTable;
//插入检查项目收藏
-(void)insertInspectthWithTitle:(NSString *)title imgUrl:(NSString *)imgUrl id:(NSInteger)id;
//查询
- (NSMutableArray *)selectInspectTable;
//删除内容
- (void)deleteInspectTableWithTitle:(NSString *)title;
//删除表
- (void)dropInspectTable;

//关闭数据库
- (void)closeDB;
@end
